APPS.AHL_PRD_RESOURCE_TRANX_PVT dependencies on WIP_TRANSACTIONS

Line 1249: -- 240 is the length of the reference column in the wip_transactions table

1245: END IF;
1246: ELSE
1247: -- if serial number is not null and ref text is null then
1248: -- simply add the serial number with short mesg prefix and without a semi colon
1249: -- 240 is the length of the reference column in the wip_transactions table
1250: IF p_x_prd_resrc_txn_tbl(i).REFERENCE IS NOT NULL THEN
1251: l_str_len := 240 - (length(p_x_prd_resrc_txn_tbl(i).serial_number) + length(l_short_mesg) + 2);
1252: l_ahl_res_txn_tbl(l_ctr).reference := substr(p_x_prd_resrc_txn_tbl(i).REFERENCE, 1, l_str_len) || '; ' || l_short_mesg || p_x_prd_resrc_txn_tbl(i).serial_number;
1253: ELSE

Line 1857: FROM WIP_TRANSACTIONS

1853: c_employee_id NUMBER )
1854: IS
1855:
1856: SELECT NVL( SUM( transaction_quantity ), 0 )
1857: FROM WIP_TRANSACTIONS
1858: WHERE wip_entity_id = c_wip_entity_id
1859: AND operation_seq_num = c_operation_seq_num
1860: AND resource_seq_num = c_resource_seq_num
1861: AND employee_id = c_employee_id;