DBA Data[Home] [Help]

APPS.INV_UOM_API_PUB dependencies on GME_MATERIAL_DETAILS

Line 1851: gme_material_details d,

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
1855: AND t.organization_id = p_org_id

Line 1971: FROM GME_MATERIAL_DETAILS

1967:
1968: CURSOR GET_MATL_LINES
1969: IS
1970: SELECT *
1971: FROM GME_MATERIAL_DETAILS
1972: WHERE BATCH_ID = X_BATCH_ID
1973: AND LINE_TYPE = X_LINE_TYPE
1974: and inventory_item_id = P_ITEM_ID;
1975:

Line 1982: X_MATL_LINE GME_MATERIAL_DETAILS%ROWTYPE;

1978: SELECT UOM_CLASS
1979: FROM MTL_UNITS_OF_MEASURE
1980: WHERE uom_code = v_uom;
1981:
1982: X_MATL_LINE GME_MATERIAL_DETAILS%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;