APPS.JMF_SHIKYU_ALLOCATION_PVT dependencies on MTL_PARAMETERS

Line 839: l_tp_organization MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;

835: l_oem_organization_id mtl_interorg_ship_methods.from_organization_id%TYPE;
836: l_tp_organization_id mtl_interorg_ship_methods.to_organization_id%TYPE;
837: l_message VARCHAR(2000);
838: l_status_flag BOOLEAN;
839: l_tp_organization MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
840: l_oem_organization MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
841:
842:
843:

Line 840: l_oem_organization MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;

836: l_tp_organization_id mtl_interorg_ship_methods.to_organization_id%TYPE;
837: l_message VARCHAR(2000);
838: l_status_flag BOOLEAN;
839: l_tp_organization MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
840: l_oem_organization MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
841:
842:
843:
844:

Line 1020: FROM mtl_parameters mip

1016: , 'tp_organization_id '||l_tp_organization_id);
1017: END IF;
1018:
1019: SELECT organization_code INTO l_oem_organization
1020: FROM mtl_parameters mip
1021: WHERE exists
1022: (SELECT 1 FROM jmf_subcontract_orders jso
1023: WHERE subcontract_po_shipment_id = p_subcontract_po_shipment_id
1024: AND jso.oem_organization_id = mip.organization_id);

Line 1028: FROM mtl_parameters mip

1024: AND jso.oem_organization_id = mip.organization_id);
1025:
1026:
1027: SELECT organization_code INTO l_tp_organization
1028: FROM mtl_parameters mip
1029: WHERE exists
1030: (SELECT 1 FROM jmf_subcontract_orders jso
1031: WHERE subcontract_po_shipment_id = p_subcontract_po_shipment_id
1032: AND jso.tp_organization_id = mip.organization_id);

Line 2242: l_tp_organization_id MTL_PARAMETERS.ORGANIZATION_ID%type;

2238: l_sub_comp MTL_SYSTEM_ITEMS_B.segment1%TYPE;
2239: l_order_number PO_HEADERS_ALL.SEGMENT1%TYPE;
2240: l_message VARCHAR(2000);
2241: l_status_flag BOOLEAN;
2242: l_tp_organization_id MTL_PARAMETERS.ORGANIZATION_ID%type;
2243:
2244:
2245: BEGIN
2246:

Line 5369: FROM mtl_parameters mtlp,

5365:
5366: -- project_control_level: Project = 1, Task = 2
5367: SELECT count(*)
5368: INTO l_count
5369: FROM mtl_parameters mtlp,
5370: jmf_subcontract_orders jso
5371: WHERE mtlp.organization_id = jso.tp_organization_id
5372: AND jso.subcontract_po_shipment_id = p_subcontract_po_shipment_id
5373: AND ( (mtlp.project_control_level = 1