DBA Data[Home] [Help]

APPS.WMS_UT_PKG dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 458: SELECT MTL_MATERIAL_TRANSACTIONS_S.nextval

454: l_trx_type_id := 32;
455: l_trx_action_id := 1;
456: l_trx_src_type_id := 13;
457: END IF;
458: SELECT MTL_MATERIAL_TRANSACTIONS_S.nextval
459: INTO l_trx_hdr_id
460: FROM DUAL;
461: print_debug('Item : ' || get_lst_val(l_txns_lst(l_ix),3));
462: l_item_id := get_item_id(p_org_id, get_lst_val(l_txns_lst(l_ix),3), p_test_id, p_runid);

Line 1550: select MTL_MATERIAL_TRANSACTIONS_S.nextval

1546: invoice_to_contact_id := 1013;
1547: end if;
1548:
1549: /* Needed a distinct doc ref id for each order */
1550: select MTL_MATERIAL_TRANSACTIONS_S.nextval
1551: into l_orig_sys_document_ref from dual;
1552:
1553:
1554: print_debug('Orig sys ref :'||l_orig_sys_document_ref);