The Sales Order Number is not stored as a separate attribute, the Workflow
tables includes the internal ID's to identify the Headers and Lines,
the value is stored on the field ITEM_KEY and is dependent on the Item
Type field as follow:
![](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAdkAAABJCAIAAAD+NMuiAAALRElEQVR4nO1dMXrrLBDkPuldvDPkEmpSvYM4XS7xOtWp/xu4UZdb5AL+C0kIlt1lkRGSrZlvi1iCZRlgBNhB7n6/3+/3YRjuAHgAAKAtvOY48vnkAA8AALTEosXDMAzD4AAAAIA9MInwJMnO3f+DOfAAg8FamnOzCEOLKS97xwCDwc5j0GKZl71jgMFg5zFosczL3jHAYLDzGLRY5mXvGGAw2HkMWizzsncMMBjsPAYtlnnZO4ZntO9355xz7/tHAoM9l2W0eK+h9SH/BO/rXyteDsBDal9vcST/3B/nnHN//tbxP9X0zf3E13/+8tf57AcgCgZ7LivU4s9JEL83DkvR4q2LXng5AA+pES2ePtaLZNLc5Jk3FpRVfGgxDLbODqrFYgAteTkSD95CLZZ08yFjJ9rzxWxB0GIYbJ0VaPH0d4BlZM5j1SXDeNSOr3/LDI56U5e96dimi/R4+cwUR/zLoVJejsQDW/0PtgpCDDpvTBHBdZry00UIUpL2GiP8+JRLtDUHDPby5tzjWvxJrzMSoEOeRqVa7CeDfk4aLp/54pL5LBsq5eVIPNzjyrp3YQYqx6Dzxjrxz5ixLJ+S2UF6j1JatdjcHDDYy5tzD+9RjEPajzc/0/kO7vqB7T+O6aVvisQA/nN3MsLj5TMpzutmeFcKlfJyJB5IKR7f3F0pBoU3YmTG/RGn/HoP4oypKNJie3PAYC9vzj2oxfEaM0QoOn5Ul268slocXmSH9zK3msP7+MyHSnk5Eg/e/Lx4mpyGzORiUHjjaR/vfjIp06lxsRaXNAcM9vLm3BNqcbiIJv7Po8XpTkK+gjJv1IJ40iZgf+UCLYbBHjHnKmmxNH420eJgEU2XzwYttgz1o/FA/IwZ6ZdshgpKvEkpPz6TnQQS6uo9ipLmgMFe3lZqcTh+0sXyz19x06CWFvtvoiIxkveLvw2hUl6OxMOdVHDMmPz+LFtBiTeR+bdkD5cVX0GL2Wh9ufbmgMFe3gq1OF6fjkoUDe9knG+kxeEKN/3pGMWcXQ+V8nIkHmgFye8WbDEovDEW/sjBsCvNarEej705YLCXN+dK/wc6GKLLrJD8OCn5OXB9LU6mwKQ48jNeNn7J88TLkXigtU6fCtLv9pIKsryx5p83ywZFUoTf7mC1+B48Ldyb+xl1/I35GYbeHDDYy5tzT3s2EPs7MOO/6pp42buCLXmDwWD72tNqsXAmzgtosXIWR4X/g6h9lhAMBqtiz6rF6X+RjQYtXscbDAbb155Vi1vwsncMMBjsPAYtlnnZOwYYDHYeW7R4GIZhGOT1MQAAALAhJhH28+Jf4PcXPAAA0BLOJXsUe4d0CIAHAABaAlrMAzwAANAS0GIe4AEAgJaAFvMADwAAtAS0mAd44HC7XlzX7x0FALwioMU8Qh76zrmuH5WIweV6Y+5NktV34acFU/rL9aaGMRe9fBo/ssXdrpe4pNv1kpaQpCpABS2eCAm5iyJjOKzlMLwX56JlSZEoDrXw4nqEVzJVHqPkrtWMPLhnbVwuMLG3qTQ9AT+GyPVCjXBWLY6DDWKltVtuqVnC2mYbrD0co8W/yhWpCnMjkbbpO+cul3ytg4Ju18tColBc34U8p1F6P+auEvt4UIuXZ0kQynKhvBuUOIz4o9z0XdJzuUgUh1qIutbILvrOdR3NXzvysM/crhfr8y8NbCst3pkfU+R6oUbYtJj0+UQWmAbMZTmRFndXerPv3OXaG2rtC4pVVu1SU2R1SK2oxaQK6cXSiEsdKoPHGIniUAtyndZMZFPOK0e+opsIgbXW4jb82CLXCzXCosVc/HFjsktwPcuZtLhPW/pyvVlqvWQ3zEF8jsv1pvSm6E64uKIO43XNvAvS9T4PbUN1gSYEFPTZwm5Q7FAfPGHqI2ixH1dkgNWOnK4tspACa6zFrfgxRa4XaoRBi3mno5788lpsyPKCWsxtF00pwxrOf1u1OC+T6fSk62TfRXOidF7sgyGilxk/0tYIGSf2LTejw3jhSdtFqKsUieJQQrKTGHmUqxwMq5jQ+pFLnYyHGNh6LT44P0rkihab9DyCUYtTn74krnZlWQo6QjO4qvPi8H70PDfNi69p11Dzct9o8MHnF1LaHkXUnqEb/9AlEZdIZxbF4q7tKpJr6hYQ71DCynlfxHSUaqPI5wS5SsmBNZ0XN+dHj7ylFmNe/KAWRzNk+05dkKmAMb0XxHfZDQcpsaLF0swmF1Rwud4eReqQMvjwSjZpEnOUFq1hGJ2TbRi5oU5KYC21eB9+5Mhb7VEYnjSmgXfi/eLlz65MemIpF2YCWqHmu8IUedW8uKBcy/cqdRzm9iiKv+EpX8mmV4SCkkxBui0jL1fOnMxto8V78SMGoRdqhEWLkydF9Jnfj8hmOZ8Wz1PQ7PpLy27S8TVarPT6eEuQ0WJj5x0nM0GyvnPUe1E3KHSoDB5jJIpDCWu0Rp1l1Y08atGsfqiBmbU40oKD86PA3p2MMGmxd0/XA3MtuLVCJssLajG3Ro9SpsJWosVhJ5aKk8LjfUYNJOTwJXW9rMUpAVLxcZFx9fVKKbXRHJJ97HD2VB6J4lCLT9eapCC2+fzjrnrkgcPiuoSB0aLZ7Suf0K7Fe/NjYUMv1AiH/7tjAR4AAGgJaDEP8AAAQEtAi3k05IGub8jq6dx4CnKeIkg7Xqw6j6ApFdBiHuABAICWcHj3KAAAwBGAd48yAA8AALSEwx4FC/AAAEBLQIt5gAcAAFoCWswDPAAA0BLQYh7gAQCAloAW8wAPHPizRwAAeBzQYh6OOY+COxrS4d2jZVDOj1h1HkWBQ3regFyWdmqBVJgAtg3SowxobOqBDOSGtUXGkgxnWmVPStmqUkrg0skPLzQ3cHu9e/TgFLqK57QxPabv8O7R5Jy18iOiShzGJwdWOM3Lds6tUbboI9dwaGTQF6wPrVovDN2mUlrkdU9EOyZsWkz6vOHMzDVZjoSaWox3j3pX7AB+5PziEof2A2crnqxokq24h+Rla0XbTk1HW3BDLS6tlAx7wz01LFrMURefXcsuwQuzHAtVtRjvHqXFpvGqlWJR7FAf0mHq5lrch5eM8+KiIeSHHBl7W2pxaaVE2BvuqWHQYvE85+UIadorVmQ5GNZoMbeJNaUMCZn/tmpxXibTmQ7ePZpEEqfnZDQmhotEcaiFaZGtwJ2ytUq+OzCvz4MRFwe0rRaXVkpARotNz8QngFGL05r6+nPEGrIcnLu68+LwfjRDMc2L8e5RDsXiHqXNa7G4BWTXENEVLy7ckkbnZI7HMjmXHygbavGaSqWAFs/AvLiCFkczZPuGbpAp2RGQ8+p9M77LbjhIiRUtpkjKV7YU2BlbFkUOKYMP71EkTSKgQLbmx0uZbBkCYdpH3RmvqcXrKmXybA73SWDQYsMcwjTwTrxfvPyJd4/KxT4yRPMOc3sUlki23KNYgrhkN3zyJUil0Rzba/G6Stk8L+5fQIr3e/fo+bR4noKW9Mgku0nH12ix4DHu6IIWF8hSlKzvHPVeNKgKHSpD2hiJ4lCL0S5bya6DqJWx0hVJMd0xM2lxMoBrV0qBueGsi5VjwqTFv7/BWpauZ+kCaLlnzXJE8tZoMbdGTycIRdLD9OnL9SYXJ4XH+4waSMjhS5p3vTktTgmQio+LjKuvV0qpjeaQ7GOHXzyWR6I4lEBddf2vPtGLHzBav2JDZwlKiPQPTzY87mKixRtUylIFteFOosUnA3gAAKAloMU8wAMAAC0BLebRkAe66jIu3M6BpyDnCEEeIYZH8OzxVwC0mAd4AACgJRzePQoAAHAERO8eHYbhDoAHAADawmsOtDgCeAAAoCWgxTzAAwAALeE153/STODuNJfzTQAAAABJRU5ErkJgggA=)
Subscribe to:
Post Comments (Atom)
Query to get the Concurrent Program along with Value Set details
SELECT fcpl1.user_concurrent_program_name ,fdfcuv.end_user_column_name ,ffvs.flex_value_set_name value_set_name ,ffvt.appl...
-
The XDOLoader utility is a Java-based command line program to load template (RTF, PDF, and XSL-FO), XML, and XSD files to the XML Publis...
-
SELECT HAOU.NAME "Operating Unit", OTTT_H.NAME "Transaction Type", OTTT_H.DESCRIPTION "Descripti...
-
Serial_number_control_code column contains values as 1,2,5 &6 in mtl_system_items_b table. Inorder to find meaning for this values r...
No comments:
Post a Comment