DBA Data[Home] [Help]

APPS.GMF_LAYERS dependencies on MTL_MATERIAL_TRANSACTIONS

Line 26: TRANSACTION_ID mtl_material_transactions.transaction_id%TYPE

22: */
23:
24: TYPE TRANS_REC_TYPE IS RECORD
25: (
26: TRANSACTION_ID mtl_material_transactions.transaction_id%TYPE
27: , TRANSACTION_SOURCE_TYPE_ID mtl_material_transactions.transaction_source_type_id%TYPE
28: , TRANSACTION_ACTION_ID mtl_material_transactions.transaction_action_id%TYPE
29: , TRANSACTION_TYPE_ID mtl_material_transactions.transaction_type_id%TYPE
30: , INVENTORY_ITEM_ID mtl_material_transactions.inventory_item_id%TYPE

Line 27: , TRANSACTION_SOURCE_TYPE_ID mtl_material_transactions.transaction_source_type_id%TYPE

23:
24: TYPE TRANS_REC_TYPE IS RECORD
25: (
26: TRANSACTION_ID mtl_material_transactions.transaction_id%TYPE
27: , TRANSACTION_SOURCE_TYPE_ID mtl_material_transactions.transaction_source_type_id%TYPE
28: , TRANSACTION_ACTION_ID mtl_material_transactions.transaction_action_id%TYPE
29: , TRANSACTION_TYPE_ID mtl_material_transactions.transaction_type_id%TYPE
30: , INVENTORY_ITEM_ID mtl_material_transactions.inventory_item_id%TYPE
31: , ORGANIZATION_ID mtl_material_transactions.organization_id%TYPE

Line 28: , TRANSACTION_ACTION_ID mtl_material_transactions.transaction_action_id%TYPE

24: TYPE TRANS_REC_TYPE IS RECORD
25: (
26: TRANSACTION_ID mtl_material_transactions.transaction_id%TYPE
27: , TRANSACTION_SOURCE_TYPE_ID mtl_material_transactions.transaction_source_type_id%TYPE
28: , TRANSACTION_ACTION_ID mtl_material_transactions.transaction_action_id%TYPE
29: , TRANSACTION_TYPE_ID mtl_material_transactions.transaction_type_id%TYPE
30: , INVENTORY_ITEM_ID mtl_material_transactions.inventory_item_id%TYPE
31: , ORGANIZATION_ID mtl_material_transactions.organization_id%TYPE
32: , LOT_NUMBER mtl_transaction_lot_numbers.lot_number%TYPE

Line 29: , TRANSACTION_TYPE_ID mtl_material_transactions.transaction_type_id%TYPE

25: (
26: TRANSACTION_ID mtl_material_transactions.transaction_id%TYPE
27: , TRANSACTION_SOURCE_TYPE_ID mtl_material_transactions.transaction_source_type_id%TYPE
28: , TRANSACTION_ACTION_ID mtl_material_transactions.transaction_action_id%TYPE
29: , TRANSACTION_TYPE_ID mtl_material_transactions.transaction_type_id%TYPE
30: , INVENTORY_ITEM_ID mtl_material_transactions.inventory_item_id%TYPE
31: , ORGANIZATION_ID mtl_material_transactions.organization_id%TYPE
32: , LOT_NUMBER mtl_transaction_lot_numbers.lot_number%TYPE
33: , TRANSACTION_DATE mtl_material_transactions.transaction_date%TYPE

Line 30: , INVENTORY_ITEM_ID mtl_material_transactions.inventory_item_id%TYPE

26: TRANSACTION_ID mtl_material_transactions.transaction_id%TYPE
27: , TRANSACTION_SOURCE_TYPE_ID mtl_material_transactions.transaction_source_type_id%TYPE
28: , TRANSACTION_ACTION_ID mtl_material_transactions.transaction_action_id%TYPE
29: , TRANSACTION_TYPE_ID mtl_material_transactions.transaction_type_id%TYPE
30: , INVENTORY_ITEM_ID mtl_material_transactions.inventory_item_id%TYPE
31: , ORGANIZATION_ID mtl_material_transactions.organization_id%TYPE
32: , LOT_NUMBER mtl_transaction_lot_numbers.lot_number%TYPE
33: , TRANSACTION_DATE mtl_material_transactions.transaction_date%TYPE
34: , PRIMARY_QUANTITY mtl_material_transactions.primary_quantity%TYPE

Line 31: , ORGANIZATION_ID mtl_material_transactions.organization_id%TYPE

27: , TRANSACTION_SOURCE_TYPE_ID mtl_material_transactions.transaction_source_type_id%TYPE
28: , TRANSACTION_ACTION_ID mtl_material_transactions.transaction_action_id%TYPE
29: , TRANSACTION_TYPE_ID mtl_material_transactions.transaction_type_id%TYPE
30: , INVENTORY_ITEM_ID mtl_material_transactions.inventory_item_id%TYPE
31: , ORGANIZATION_ID mtl_material_transactions.organization_id%TYPE
32: , LOT_NUMBER mtl_transaction_lot_numbers.lot_number%TYPE
33: , TRANSACTION_DATE mtl_material_transactions.transaction_date%TYPE
34: , PRIMARY_QUANTITY mtl_material_transactions.primary_quantity%TYPE
35: , PRIMARY_UOM mtl_system_items_b.primary_uom_code%TYPE

Line 33: , TRANSACTION_DATE mtl_material_transactions.transaction_date%TYPE

29: , TRANSACTION_TYPE_ID mtl_material_transactions.transaction_type_id%TYPE
30: , INVENTORY_ITEM_ID mtl_material_transactions.inventory_item_id%TYPE
31: , ORGANIZATION_ID mtl_material_transactions.organization_id%TYPE
32: , LOT_NUMBER mtl_transaction_lot_numbers.lot_number%TYPE
33: , TRANSACTION_DATE mtl_material_transactions.transaction_date%TYPE
34: , PRIMARY_QUANTITY mtl_material_transactions.primary_quantity%TYPE
35: , PRIMARY_UOM mtl_system_items_b.primary_uom_code%TYPE
36: , DOC_QTY NUMBER
37: , DOC_UOM gme_material_details.dtl_um%TYPE

Line 34: , PRIMARY_QUANTITY mtl_material_transactions.primary_quantity%TYPE

30: , INVENTORY_ITEM_ID mtl_material_transactions.inventory_item_id%TYPE
31: , ORGANIZATION_ID mtl_material_transactions.organization_id%TYPE
32: , LOT_NUMBER mtl_transaction_lot_numbers.lot_number%TYPE
33: , TRANSACTION_DATE mtl_material_transactions.transaction_date%TYPE
34: , PRIMARY_QUANTITY mtl_material_transactions.primary_quantity%TYPE
35: , PRIMARY_UOM mtl_system_items_b.primary_uom_code%TYPE
36: , DOC_QTY NUMBER
37: , DOC_UOM gme_material_details.dtl_um%TYPE
38: , TRANSACTION_SOURCE_ID mtl_material_transactions.transaction_source_id%TYPE

Line 38: , TRANSACTION_SOURCE_ID mtl_material_transactions.transaction_source_id%TYPE

34: , PRIMARY_QUANTITY mtl_material_transactions.primary_quantity%TYPE
35: , PRIMARY_UOM mtl_system_items_b.primary_uom_code%TYPE
36: , DOC_QTY NUMBER
37: , DOC_UOM gme_material_details.dtl_um%TYPE
38: , TRANSACTION_SOURCE_ID mtl_material_transactions.transaction_source_id%TYPE
39: , TRX_SOURCE_LINE_ID mtl_material_transactions.trx_source_line_id%TYPE
40: , REVERSE_ID mtl_material_transactions.source_line_id%TYPE
41: , LINE_TYPE gme_material_details.line_type%TYPE
42: , LAST_UPDATED_BY mtl_material_transactions.last_updated_by%TYPE

Line 39: , TRX_SOURCE_LINE_ID mtl_material_transactions.trx_source_line_id%TYPE

35: , PRIMARY_UOM mtl_system_items_b.primary_uom_code%TYPE
36: , DOC_QTY NUMBER
37: , DOC_UOM gme_material_details.dtl_um%TYPE
38: , TRANSACTION_SOURCE_ID mtl_material_transactions.transaction_source_id%TYPE
39: , TRX_SOURCE_LINE_ID mtl_material_transactions.trx_source_line_id%TYPE
40: , REVERSE_ID mtl_material_transactions.source_line_id%TYPE
41: , LINE_TYPE gme_material_details.line_type%TYPE
42: , LAST_UPDATED_BY mtl_material_transactions.last_updated_by%TYPE
43: , CREATED_BY mtl_material_transactions.created_by%TYPE

Line 40: , REVERSE_ID mtl_material_transactions.source_line_id%TYPE

36: , DOC_QTY NUMBER
37: , DOC_UOM gme_material_details.dtl_um%TYPE
38: , TRANSACTION_SOURCE_ID mtl_material_transactions.transaction_source_id%TYPE
39: , TRX_SOURCE_LINE_ID mtl_material_transactions.trx_source_line_id%TYPE
40: , REVERSE_ID mtl_material_transactions.source_line_id%TYPE
41: , LINE_TYPE gme_material_details.line_type%TYPE
42: , LAST_UPDATED_BY mtl_material_transactions.last_updated_by%TYPE
43: , CREATED_BY mtl_material_transactions.created_by%TYPE
44: , LAST_UPDATE_LOGIN mtl_material_transactions.last_update_login%TYPE

Line 42: , LAST_UPDATED_BY mtl_material_transactions.last_updated_by%TYPE

38: , TRANSACTION_SOURCE_ID mtl_material_transactions.transaction_source_id%TYPE
39: , TRX_SOURCE_LINE_ID mtl_material_transactions.trx_source_line_id%TYPE
40: , REVERSE_ID mtl_material_transactions.source_line_id%TYPE
41: , LINE_TYPE gme_material_details.line_type%TYPE
42: , LAST_UPDATED_BY mtl_material_transactions.last_updated_by%TYPE
43: , CREATED_BY mtl_material_transactions.created_by%TYPE
44: , LAST_UPDATE_LOGIN mtl_material_transactions.last_update_login%TYPE
45: );
46:

Line 43: , CREATED_BY mtl_material_transactions.created_by%TYPE

39: , TRX_SOURCE_LINE_ID mtl_material_transactions.trx_source_line_id%TYPE
40: , REVERSE_ID mtl_material_transactions.source_line_id%TYPE
41: , LINE_TYPE gme_material_details.line_type%TYPE
42: , LAST_UPDATED_BY mtl_material_transactions.last_updated_by%TYPE
43: , CREATED_BY mtl_material_transactions.created_by%TYPE
44: , LAST_UPDATE_LOGIN mtl_material_transactions.last_update_login%TYPE
45: );
46:
47: PROCEDURE Create_Incoming_Layers

Line 44: , LAST_UPDATE_LOGIN mtl_material_transactions.last_update_login%TYPE

40: , REVERSE_ID mtl_material_transactions.source_line_id%TYPE
41: , LINE_TYPE gme_material_details.line_type%TYPE
42: , LAST_UPDATED_BY mtl_material_transactions.last_updated_by%TYPE
43: , CREATED_BY mtl_material_transactions.created_by%TYPE
44: , LAST_UPDATE_LOGIN mtl_material_transactions.last_update_login%TYPE
45: );
46:
47: PROCEDURE Create_Incoming_Layers
48: ( p_api_version IN NUMBER,