DBA Data[Home] [Help]

APPS.INV_UOM_API_PUB dependencies on GME_BATCH_HEADER

Line 1850: FROM gme_batch_header b,

1846: b.parentline_id,
1847: d.phantom_id,
1848: D.DTL_UM,
1849: t.opm_costed_flag
1850: FROM gme_batch_header b,
1851: gme_material_details d,
1852: mtl_material_transactions t,
1853: mtl_transaction_lot_numbers l
1854: WHERE t.inventory_item_id = p_item_id

Line 1966: SELECT * FROM GME_BATCH_HEADER WHERE BATCH_ID = NVL(X_PHANTOM_ID, X_BATCH_ID);

1962: L_LOGINID NUMBER := FND_GLOBAL.LOGIN_ID;
1963:
1964: CURSOR GET_BATCH
1965: IS
1966: SELECT * FROM GME_BATCH_HEADER WHERE BATCH_ID = NVL(X_PHANTOM_ID, X_BATCH_ID);
1967:
1968: CURSOR GET_MATL_LINES
1969: IS
1970: SELECT *

Line 1987: X_BATCH_ROW GME_BATCH_HEADER%ROWTYPE;

1983: l_tracking_quantity_ind mtl_system_items_b.tracking_quantity_ind%TYPE;
1984: l_secondary_def_ind mtl_system_items_b.secondary_default_ind%TYPE;
1985: l_lot_divisible_flag mtl_system_items_b.lot_divisible_flag%TYPE;
1986: L_QTY_TBL MTL_LOT_UOM_CONV_PUB.QUANTITY_UPDATE_REC_TYPE;
1987: X_BATCH_ROW GME_BATCH_HEADER%ROWTYPE;
1988:
1989: -- L_FROM_CLASS VARCHAR2(100);
1990: L_FROM_CLASS MTL_UOM_CLASSES_TL.UOM_CLASS_TL%TYPE;
1991: