DBA Data[Home] [Help]

APPS.INV_LABEL_PVT4 dependencies on MTL_PARAMETERS

Line 33: p_organization_id MTL_PARAMETERS.ORGANIZATION_ID%TYPE := null;

29: , p_input_param IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE
30: , p_transaction_identifier IN NUMBER
31: ) IS
32:
33: p_organization_id MTL_PARAMETERS.ORGANIZATION_ID%TYPE := null;
34: p_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE := null;
35: p_lot_number MTL_LOT_NUMBERS.LOT_NUMBER%TYPE :=null;
36: p_revision MTL_MATERIAL_TRANSACTIONS_TEMP.REVISION%TYPE := null;
37: p_qty MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_QUANTITY%TYPE := null;

Line 761: FROM mtl_parameters mp

757: , mtlt.origination_type
758: , mtlt. hold_date
759: , mtlt.expiration_action_code
760: , mtlt.supplier_lot_number
761: FROM mtl_parameters mp
762: , mtl_system_items_kfv msik
763: , mtl_transaction_lots_temp mtlt
764: , mtl_material_transactions_temp mmtt
765: , po_hazard_classes poh

Line 870: FROM mtl_parameters mp

866: , mln.origination_type
867: , mln.hold_date
868: , mln.expiration_action_code
869: , mln.supplier_lot_number -- invconv fabdi end
870: FROM mtl_parameters mp
871: , mtl_system_items_kfv msik
872: , mtl_lot_numbers mln
873: , po_hazard_classes poh
874: , mtl_material_statuses_vl mmsv