APPS.CSP_PICK_UTILS dependencies on CSP_PICKLIST_LINES

Line 611: FROM csp_picklist_lines

607: EXIT WHEN txn_temp_cur%NOTFOUND;
608:
609: SELECT count(1)
610: INTO l_cpll_rows
611: FROM csp_picklist_lines
612: WHERE transaction_temp_id = txn_temp_rec.transaction_temp_id;
613:
614: IF (nvl(l_cpll_rows, 0) = 0) THEN
615:

Line 680: SELECT csp_picklist_lines_s1.nextval

676: END IF;
677:
678: l_line_number := (l_line_number + 1);
679:
680: SELECT csp_picklist_lines_s1.nextval
681: INTO l_picklist_line_id
682: FROM dual;
683:
684: CSP_PC_FORM_PICKLINES.Validate_And_Write (

Line 856: FROM csp_picklist_lines

852:
853: CURSOR l_Get_Picklist_Lines_Csr IS
854: SELECT picklist_line_id, picklist_header_id, line_id, inventory_item_id,
855: quantity_picked, transaction_temp_id
856: FROM csp_picklist_lines
857: WHERE picklist_header_id = p_picklist_header_id;
858:
859: CURSOR l_Get_Mmtt_Csr (l_transaction_temp_id NUMBER) IS
860: SELECT item_serial_control_code, item_lot_control_code

Line 1729: FROM csp_picklist_lines

1725:
1726: CURSOR pickline_cur IS
1727: SELECT sum(quantity_picked) qty_det,
1728: line_id
1729: FROM csp_picklist_lines
1730: WHERE picklist_header_id = p_picklist_header_id
1731: GROUP BY line_id;
1732:
1733: pickline_rec pickline_cur%ROWTYPE;