APPS.CST_EAMCOST_PUB dependencies on WIP_OPERATIONS

Line 872: FROM wip_operations

868:
869: l_stmt_num := 73;
870: SELECT department_id
871: INTO l_dept_id
872: FROM wip_operations
873: WHERE wip_entity_id = p_wip_entity_id
874: AND operation_seq_num = p_opseq_num
875: AND organization_id = p_org_id;
876:

Line 2049: FROM wip_operations

2045:
2046: l_stmt_num := 220;
2047: SELECT count(*)
2048: INTO l_ops_exists
2049: FROM wip_operations
2050: WHERE wip_entity_id = p_wip_entity_id
2051: AND operation_seq_num = p_opseq_num;
2052:
2053: IF (p_txn_mode = 1) OR -- material or dept ovhd or direct item txns

Line 2063: wip_operations wo

2059: l_stmt_num := 230;
2060: SELECT bd.department_id
2061: INTO l_dept_id
2062: FROM bom_departments bd,
2063: wip_operations wo
2064: WHERE bd.department_id = wo.department_id
2065: AND wo.wip_entity_id = p_wip_entity_id
2066: AND wo.operation_seq_num = p_opseq_num;
2067: END IF; -- end checking operation

Line 2080: wip_operations wo,

2076: DECODE(bdr.share_from_dept_id,null,bdr.department_id,
2077: bdr.share_from_dept_id)
2078: INTO l_dept_id, l_owning_dept_id
2079: FROM wip_operation_resources wor,
2080: wip_operations wo,
2081: bom_department_resources bdr
2082: WHERE bdr.department_id =
2083: decode(wor.department_id,null,
2084: wo.department_id, wor.department_id)

Line 3098: FROM wip_operations wo,

3094: 1) ,l_ext_precision)) dbo_value,
3095: cdo.department_id department_id ,
3096: wo.operation_seq_num operation_seq_num
3097:
3098: FROM wip_operations wo,
3099: cst_department_overheads cdo
3100: WHERE cdo.cost_type_id = l_rates_ct
3101: AND cdo.organization_id = l_organization_id
3102: AND cdo.department_id = wo.department_id

Line 4841: FROM wip_operations wo

4837: l_stmt_num := 180;
4838:
4839: SELECT department_id
4840: INTO l_dept_id
4841: FROM wip_operations wo
4842: WHERE wo.wip_entity_id = p_wip_entity_id
4843: AND wo.operation_seq_num = c_pda_rec.operation_seq_num;
4844:
4845: IF (p_debug = 'Y') THEN

Line 6620: from wip_operations wo,

6616: select wo.department_id,
6617: bd.department_code
6618: into l_directItem_rec.department_id,
6619: l_directitem_rec.department_code
6620: from wip_operations wo,
6621: bom_departments bd
6622: where wo.wip_entity_id = l_directItem_rec.wip_entity_id
6623: and wo.operation_seq_num = l_directItem_rec.operation_seq_num
6624: and wo.organization_id = l_directItem_rec.organization_id

Line 10629: wip_operations wo,

10625: mtl_units_of_measure uom,
10626: po_headers_all poh,
10627: wip_eam_direct_items wed,
10628: hr_organization_information hoi,
10629: wip_operations wo,
10630: (SELECT
10631: pd1.wip_entity_id,
10632: pd1.wip_operation_seq_num,
10633: pd1.destination_organization_id,

Line 10809: wip_operations wo

10805: po_line_types plt,
10806: mtl_units_of_measure uom,
10807: wip_eam_direct_items wed,
10808: hr_organization_information hoi,
10809: wip_operations wo
10810: WHERE
10811: rql.requisition_header_id = rqh.requisition_header_id AND
10812: rql.line_type_id = plt.line_type_id AND
10813: rql.unit_meas_lookup_code = uom.unit_of_measure (+) AND