DBA Data[Home] [Help]

APPS.INV_LABEL_PVT7 dependencies on INV_GLOBALS

Line 47: AND mmt.transaction_source_type_id IN (INV_GLOBALS.G_SOURCETYPE_SALESORDER,INV_GLOBALS.G_SOURCETYPE_INTORDER)

43: wsh_delivery_details wdd
44: WHERE mmtt.transaction_temp_id = p_transaction_id
45: AND wda.delivery_id = p_delivery_id
46: AND mmt.organization_id = mmtt.organization_id
47: AND mmt.transaction_source_type_id IN (INV_GLOBALS.G_SOURCETYPE_SALESORDER,INV_GLOBALS.G_SOURCETYPE_INTORDER)
48: AND mmt.transaction_action_id = INV_GLOBALS.G_ACTION_STGXFR
49: AND mmtt.transfer_lpn_id = mmt.transfer_lpn_id
50: AND mmt.move_order_line_id = wdd.move_order_line_id
51: AND wda.delivery_detail_id = wdd.delivery_detail_id

Line 48: AND mmt.transaction_action_id = INV_GLOBALS.G_ACTION_STGXFR

44: WHERE mmtt.transaction_temp_id = p_transaction_id
45: AND wda.delivery_id = p_delivery_id
46: AND mmt.organization_id = mmtt.organization_id
47: AND mmt.transaction_source_type_id IN (INV_GLOBALS.G_SOURCETYPE_SALESORDER,INV_GLOBALS.G_SOURCETYPE_INTORDER)
48: AND mmt.transaction_action_id = INV_GLOBALS.G_ACTION_STGXFR
49: AND mmtt.transfer_lpn_id = mmt.transfer_lpn_id
50: AND mmt.move_order_line_id = wdd.move_order_line_id
51: AND wda.delivery_detail_id = wdd.delivery_detail_id
52: AND ROWNUM<2;