[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
| This function returns the l_sql_str, which is a SQL select string. |
| This l_sql_str is by default set to return NULL. If desired this can |
| be changed, to return the SQL select statement like 'Select ....from |
| custom_table(s) ..'. |
| |
| NOTE : The SQL string that you return in l_sql_str should be compatible with the |
| one in the Example below. Also, the Max allowed length for l_sql_str is |
| 5000 Characters/VARCHAR2(5000). |
| |
| Example: Below the XXX_ITM_TOP_MODEL_INFO is an example of a Custom Table that |
| can be Pre-Populated during the Delivery Export Screening by adding |
| your required code in the above PROCEDURE PRE_PROCESS_WSH_REQUEST (); |
| ' SELECT |
| TMI.INVENTORY_ITEM_ID, TMI.ORGANIZATION_ID, TMI.ORGANIZATION_CODE, |
| TMI.OPERATING_UNIT, TMI.PRODUCT_CODE , TMI.ITEM_TYPE,TMI.UNIT_OF_MEASURE,|
| TMI.INCOMING_CURRENCY, |
| TMI.TOP_MODEL_LINE_ID, -- TopMost/GrandParent Source Line Id in the BOM |
| TMI.PARENT_LINE_ID, -- Source Line Id of the Parent |
| TMI.LINE_ID, -- Source Line Id of the Delivery Detail involved |
| TMI.LINE_NUMBER, -- Source Line Number of the Del.Detail involved |
| TMI.ORDERED_QUANTITY ORDER_QTY, -- Source Ordered Quantity |
| TMI.ATO_LINE_ID , -- Source Line id if the Source Line is an ATO |
| TMI.ATO_FLAG, -- 'Y' , if the line involved is an ATO |
| TMI.OPT_FLAG, -- 'Y', if it an Option |
| TMI.SHIPPABLE_FLAG, -- 'Y', if the line is Shippable |
| TMI.ITEM_TYPE_CODE, TMI.UNIT_LIST_PRICE, TMI.UNIT_SELLING_PRICE |
| FROM |
| XXX_ITM_TOP_MODEL_INFO TMI |
| WHERE |
| TMI.REQUEST_CONTROL_ID = RC.REQUEST_CONTROL_ID |
| AND TMI.ORIGINAL_SYSTEM_REFERENCE = SHPMNTITM.DELIVERY_ID |
| AND TMI.ORIGINAL_SYSTEM_LINE_REFERENCE = SHPMNTITM.DELIVERY_DETAIL_ID'; |