APPS.CST_EAMCOST_PUB dependencies on WIP_OPERATIONS

Line 650: FROM wip_operations

646:
647: l_stmt_num := 73;
648: SELECT department_id
649: INTO l_dept_id
650: FROM wip_operations
651: WHERE wip_entity_id = p_wip_entity_id
652: AND operation_seq_num = p_opseq_num
653: AND organization_id = p_org_id;
654:

Line 1827: FROM wip_operations

1823:
1824: l_stmt_num := 220;
1825: SELECT count(*)
1826: INTO l_ops_exists
1827: FROM wip_operations
1828: WHERE wip_entity_id = p_wip_entity_id
1829: AND operation_seq_num = p_opseq_num;
1830:
1831: IF (p_txn_mode = 1) OR -- material or dept ovhd or direct item txns

Line 1841: wip_operations wo

1837: l_stmt_num := 230;
1838: SELECT bd.department_id
1839: INTO l_dept_id
1840: FROM bom_departments bd,
1841: wip_operations wo
1842: WHERE bd.department_id = wo.department_id
1843: AND wo.wip_entity_id = p_wip_entity_id
1844: AND wo.operation_seq_num = p_opseq_num;
1845: END IF; -- end checking operation

Line 1858: wip_operations wo,

1854: DECODE(bdr.share_from_dept_id,null,bdr.department_id,
1855: bdr.share_from_dept_id)
1856: INTO l_dept_id, l_owning_dept_id
1857: FROM wip_operation_resources wor,
1858: wip_operations wo,
1859: bom_department_resources bdr
1860: WHERE bdr.department_id =
1861: decode(wor.department_id,null,
1862: wo.department_id, wor.department_id)

Line 2876: FROM wip_operations wo,

2872: 1) ,l_ext_precision)) dbo_value,
2873: cdo.department_id department_id ,
2874: wo.operation_seq_num operation_seq_num
2875:
2876: FROM wip_operations wo,
2877: cst_department_overheads cdo
2878: WHERE cdo.cost_type_id = l_rates_ct
2879: AND cdo.organization_id = l_organization_id
2880: AND cdo.department_id = wo.department_id

Line 4619: FROM wip_operations wo

4615: l_stmt_num := 180;
4616:
4617: SELECT department_id
4618: INTO l_dept_id
4619: FROM wip_operations wo
4620: WHERE wo.wip_entity_id = p_wip_entity_id
4621: AND wo.operation_seq_num = c_pda_rec.operation_seq_num;
4622:
4623: IF (p_debug = 'Y') THEN

Line 6266: from wip_operations wo,

6262: select wo.department_id,
6263: bd.department_code
6264: into l_directItem_rec.department_id,
6265: l_directitem_rec.department_code
6266: from wip_operations wo,
6267: bom_departments bd
6268: where wo.wip_entity_id = l_directItem_rec.wip_entity_id
6269: and wo.operation_seq_num = l_directItem_rec.operation_seq_num
6270: and wo.organization_id = l_directItem_rec.organization_id

Line 9916: wip_operations wo,

9912: mtl_units_of_measure uom,
9913: po_headers_all poh,
9914: wip_eam_direct_items wed,
9915: hr_organization_information hoi,
9916: wip_operations wo,
9917: (SELECT
9918: pd1.wip_entity_id,
9919: pd1.wip_operation_seq_num,
9920: pd1.destination_organization_id,

Line 10096: wip_operations wo

10092: po_line_types plt,
10093: mtl_units_of_measure uom,
10094: wip_eam_direct_items wed,
10095: hr_organization_information hoi,
10096: wip_operations wo
10097: WHERE
10098: rql.requisition_header_id = rqh.requisition_header_id AND
10099: rql.line_type_id = plt.line_type_id AND
10100: rql.unit_meas_lookup_code = uom.unit_of_measure (+) AND