APPS.WSH_PR_PICKING_OBJECTS dependencies on SO_LINE_DETAILS

Line 1667: SELECT SO_LINE_DETAILS_S.NEXTVAL

1663: BEGIN
1664: WSH_UTIL.Write_Log('--------------------');
1665: WSH_UTIL.Write_Log('Inserting new order line detail');
1666:
1667: SELECT SO_LINE_DETAILS_S.NEXTVAL
1668: INTO p_new_line_detail_id
1669: FROM DUAL;
1670:
1671: INSERT INTO SO_LINE_DETAILS (

Line 1671: INSERT INTO SO_LINE_DETAILS (

1667: SELECT SO_LINE_DETAILS_S.NEXTVAL
1668: INTO p_new_line_detail_id
1669: FROM DUAL;
1670:
1671: INSERT INTO SO_LINE_DETAILS (
1672: LINE_DETAIL_ID,
1673: CREATION_DATE,
1674: CREATED_BY,
1675: LAST_UPDATE_DATE,

Line 1811: FROM SO_LINE_DETAILS

1807: LATEST_ACCEPTABLE_DATE_SVRID,
1808: DEP_PLAN_REQUIRED_FLAG,
1809: CUSTOMER_ITEM_ID,
1810: LOAD_SEQ_NUMBER
1811: FROM SO_LINE_DETAILS
1812: WHERE line_detail_id = p_original_line_detail_id;
1813:
1814: rows_inserted := SQL%ROWCOUNT;
1815: