APPS.WMS_CARTNZN_PUB dependencies on MTL_PARAMETERS

Line 3295: mtl_parameters mtlp

3291: CURSOR wct_rows IS
3292: SELECT wct.* FROM wms_cartonization_temp wct,
3293: mtl_txn_request_lines mtrl,
3294: mtl_secondary_inventories sub,
3295: mtl_parameters mtlp
3296: WHERE
3297: wct.move_order_line_id =mtrl.line_id
3298: AND mtrl.header_id = p_move_order_header_id
3299: AND wct.cartonization_id IS null

Line 3479: FROM mtl_parameters

3475: l_cartonize_manufacturing,
3476: --Bug 3528061 fix
3477: g_allocate_serial_flag,
3478: wms_cartnzn_pub.g_default_pick_op_plan_id
3479: FROM mtl_parameters
3480: WHERE organization_id = p_org_id;
3481:
3482: wms_cartnzn_pub.g_org_cartonization_value := v_cart_value;
3483: wms_cartnzn_pub.g_org_cartonize_so_flag := l_cartonize_sales_orders;

Line 5967: mtl_parameters mtlp

5963: CURSOR wct_rows IS
5964: SELECT wct.* FROM wms_cartonization_temp wct,
5965: mtl_txn_request_lines mtrl,
5966: mtl_secondary_inventories sub,
5967: mtl_parameters mtlp
5968: WHERE
5969: wct.move_order_line_id =mtrl.line_id
5970: AND mtrl.header_id = p_move_order_header_id
5971: AND wct.cartonization_id IS null

Line 5986: mtl_parameters mtlp

5982: CURSOR wct_sub_rows IS
5983: SELECT wct.* FROM wms_cartonization_temp wct,
5984: mtl_txn_request_lines mtrl,
5985: mtl_secondary_inventories sub,
5986: mtl_parameters mtlp
5987: WHERE
5988: wct.move_order_line_id =mtrl.line_id
5989: AND mtrl.header_id = p_move_order_header_id
5990: AND wct.cartonization_id IS null

Line 6724: mtl_parameters mtlp

6720: CURSOR wct_rows IS
6721: SELECT wct.* FROM wms_cartonization_temp wct,
6722: mtl_txn_request_lines mtrl,
6723: mtl_secondary_inventories sub,
6724: mtl_parameters mtlp
6725: WHERE
6726: wct.move_order_line_id =mtrl.line_id
6727: AND mtrl.header_id = p_move_order_header_id
6728: AND wct.cartonization_id IS null

Line 7259: mtl_parameters mtlp

7255: CURSOR wct_rows IS
7256: SELECT wct.* FROM wms_cartonization_temp wct,
7257: mtl_txn_request_lines mtrl,
7258: mtl_secondary_inventories sub,
7259: mtl_parameters mtlp
7260: WHERE
7261: wct.move_order_line_id =mtrl.line_id
7262: AND mtrl.header_id = p_move_order_header_id
7263: AND wct.cartonization_id IS null

Line 7684: mtl_parameters mtlp,

7680: IS
7681: SELECT DISTINCT wct.pick_slip_number
7682: FROM wms_cartonization_temp wct,
7683: mtl_txn_request_lines mtrl,
7684: mtl_parameters mtlp,
7685: mtl_secondary_inventories sub
7686: WHERE mtrl.header_id = p_move_order_header_id
7687: AND mtrl.organization_id = p_org_id
7688: AND wct.move_order_line_id = mtrl.line_id

Line 7703: mtl_parameters mtlp,

7699: IS
7700: SELECT DISTINCT wct.pick_slip_number
7701: FROM wms_cartonization_temp wct,
7702: mtl_txn_request_lines mtrl,
7703: mtl_parameters mtlp,
7704: mtl_secondary_inventories sub
7705: WHERE mtrl.header_id = p_move_order_header_id
7706: AND mtrl.organization_id = p_org_id
7707: AND wct.move_order_line_id = mtrl.line_id

Line 8106: mtl_parameters mtlp

8102: SELECT wct.* BULK COLLECT INTO l_mmtt_table
8103: FROM wms_cartonization_temp wct,
8104: mtl_txn_request_lines mtrl,
8105: mtl_secondary_inventories sub,
8106: mtl_parameters mtlp
8107: WHERE wct.move_order_line_id =mtrl.line_id
8108: AND mtrl.header_id = p_move_order_header_id
8109: AND mtlp.organization_id = wct.organization_id
8110: AND sub.organization_id = wct.organization_id

Line 8127: mtl_parameters mtlp

8123: SELECT wct.* BULK COLLECT INTO l_mmtt_table
8124: FROM wms_cartonization_temp wct,
8125: mtl_txn_request_lines mtrl,
8126: mtl_secondary_inventories sub,
8127: mtl_parameters mtlp
8128: WHERE wct.move_order_line_id =mtrl.line_id
8129: AND mtrl.header_id = p_move_order_header_id
8130: AND mtlp.organization_id = wct.organization_id
8131: AND sub.secondary_inventory_name = wct.subinventory_code