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 1016: FROM mtl_parameters mip

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

Line 1024: FROM mtl_parameters mip

1020: AND jso.oem_organization_id = mip.organization_id);
1021:
1022:
1023: SELECT organization_code INTO l_tp_organization
1024: FROM mtl_parameters mip
1025: WHERE exists
1026: (SELECT 1 FROM jmf_subcontract_orders jso
1027: WHERE subcontract_po_shipment_id = p_subcontract_po_shipment_id
1028: AND jso.tp_organization_id = mip.organization_id);

Line 2236: l_tp_organization_id MTL_PARAMETERS.ORGANIZATION_ID%type;

2232: l_sub_comp MTL_SYSTEM_ITEMS_B.segment1%TYPE;
2233: l_order_number PO_HEADERS_ALL.SEGMENT1%TYPE;
2234: l_message VARCHAR(2000);
2235: l_status_flag BOOLEAN;
2236: l_tp_organization_id MTL_PARAMETERS.ORGANIZATION_ID%type;
2237:
2238:
2239: BEGIN
2240:

Line 4925: FROM mtl_parameters mtlp,

4921:
4922: -- project_control_level: Project = 1, Task = 2
4923: SELECT count(*)
4924: INTO l_count
4925: FROM mtl_parameters mtlp,
4926: jmf_subcontract_orders jso
4927: WHERE mtlp.organization_id = jso.tp_organization_id
4928: AND jso.subcontract_po_shipment_id = p_subcontract_po_shipment_id
4929: AND ( (mtlp.project_control_level = 1