APPS.WSMPINVL dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 973: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL

969:
970:
971: BEGIN
972:
973: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
974: INTO X_Header_Id
975: FROM DUAL;
976:
977: return(X_Header_Id);

Line 987: return(MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL);

983: FUNCTION Get_Header_Id RETURN NUMBER IS
984:
985: BEGIN
986:
987: return(MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL);
988:
989: END Get_Header_Id;
990: */
991:

Line 4323: /*SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL

4319: l_stmt_num :=10;
4320: Set_Vars;
4321:
4322: --commented out by abedajna for perf. tuning
4323: /*SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
4324: **INTO X_Temp_Id
4325: **FROM DUAL;
4326: */
4327:

Line 4440: MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL, /* abedajna, tuning */

4436: X_Reference, /* TRANSACTION_REFERENCE */
4437: 'Y', /* PROCESS_FLAG */
4438: 'Y', /* POSTING_FLAG */
4439: -- abb X_temp_id, /* Transaction Temp Id */
4440: MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL, /* abedajna, tuning */
4441: X_revision,
4442: X_Dist_Acct_Id, /* distribution_account_id */
4443: 'WSM', /* Source Code */
4444: X_Source_Line_Id /* Transaction Id in WLSMI table */

Line 4719: /*SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL

4715:
4716: l_stmt_num :=10;
4717:
4718: --commented out by abedajna for perf. tuning
4719: /*SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
4720: **INTO X_Temp_Id
4721: **FROM DUAL;
4722: */
4723:

Line 4828: MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL, /* abedajna, tuning */

4824: X_Reference, /* TRANSACTION_REFERENCE */
4825: 'Y', /* PROCESS_FLAG */
4826: 'Y', /* POSTING_FLAG */
4827: -- abb X_temp_id, /* Transaction Temp Id */
4828: MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL, /* abedajna, tuning */
4829: X_Dist_Acct_Id, /* distribution account id */
4830: 'WSM', /* Source Code */
4831: X_Source_Line_Id /* Transaction Id in WLSMI table */
4832: /*BA#IIIP*/