DBA Data[Home] [Help]

APPS.GMI_SHIPPING_UTIL dependencies on MTL_PARAMETERS

Line 3011: , mtl_parameters mp1

3007: , wdd.released_status SHIP_STATUS
3008: FROM wsh_delivery_details wdd
3009: , oe_order_headers_all soh
3010: , oe_order_lines_all sol
3011: , mtl_parameters mp1
3012: , mtl_parameters mp2
3013: WHERE wdd.source_line_id = sol.line_id
3014: AND mp1.organization_id = sol.org_id
3015: AND mp2.organization_id = sol.ship_from_org_id

Line 3012: , mtl_parameters mp2

3008: FROM wsh_delivery_details wdd
3009: , oe_order_headers_all soh
3010: , oe_order_lines_all sol
3011: , mtl_parameters mp1
3012: , mtl_parameters mp2
3013: WHERE wdd.source_line_id = sol.line_id
3014: AND mp1.organization_id = sol.org_id
3015: AND mp2.organization_id = sol.ship_from_org_id
3016: AND sol.flow_status_code = 'AWAITING_SHIPPING'

Line 3072: , mtl_parameters mp1

3068: FROM ic_txn_request_lines mo
3069: , wsh_delivery_details wdd
3070: , oe_order_headers_all soh
3071: , oe_order_lines_all sol
3072: , mtl_parameters mp1
3073: , mtl_parameters mp2
3074: Where soh.header_id = sol.header_id
3075: and sol.line_id = mo.txn_source_line_id
3076: AND sol.flow_status_code = 'AWAITING_SHIPPING'

Line 3073: , mtl_parameters mp2

3069: , wsh_delivery_details wdd
3070: , oe_order_headers_all soh
3071: , oe_order_lines_all sol
3072: , mtl_parameters mp1
3073: , mtl_parameters mp2
3074: Where soh.header_id = sol.header_id
3075: and sol.line_id = mo.txn_source_line_id
3076: AND sol.flow_status_code = 'AWAITING_SHIPPING'
3077: AND mp1.organization_id = sol.org_id